/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80030 (8.0.30)
 Source Host           : 127.0.0.1:3306
 Source Schema         : gin_test

 Target Server Type    : MySQL
 Target Server Version : 80030 (8.0.30)
 File Encoding         : 65001

 Date: 02/01/2025 18:44:33
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门编号',
  `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '父节点id',
  `tree_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '父节点id路径',
  `sort` smallint DEFAULT '0' COMMENT '显示顺序',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态(1-正常 0-禁用)',
  `create_by` bigint DEFAULT NULL COMMENT '创建人ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除标识(1-已删除 0-未删除)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_code` (`code`) USING BTREE COMMENT '部门编号唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `name`, `code`, `parent_id`, `tree_path`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (1, '有来技术', 'YOULAI', 0, '0', 1, 1, 1, NULL, 1, '2024-06-24 23:48:59', 0);
INSERT INTO `sys_dept` (`id`, `name`, `code`, `parent_id`, `tree_path`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (2, '研发部门', 'RD001', 1, '0,1', 1, 1, 2, NULL, 2, '2022-04-19 12:46:37', 0);
INSERT INTO `sys_dept` (`id`, `name`, `code`, `parent_id`, `tree_path`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (3, '测试部门', 'QA001', 1, '0,1', 1, 1, 2, NULL, 2, '2022-04-19 12:46:37', 0);
INSERT INTO `sys_dept` (`id`, `name`, `code`, `parent_id`, `tree_path`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (4, '设计部', 'UI001', 1, '0,1', 1, 1, 2, '2024-07-14 21:37:11', NULL, '2024-07-14 21:37:11', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '类型名称',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '类型编码',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态(0:正常;1:禁用)',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint DEFAULT '0' COMMENT '是否删除(1-删除，0-未删除)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`id`, `name`, `code`, `status`, `remark`, `create_time`, `update_time`, `is_deleted`) VALUES (1, '性别', 'gender', 1, NULL, '2019-12-06 19:03:32', '2024-06-22 21:14:47', 0);
INSERT INTO `sys_dict` (`id`, `name`, `code`, `status`, `remark`, `create_time`, `update_time`, `is_deleted`) VALUES (102, '资源类型', 'sourceType', 1, NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dict_id` bigint DEFAULT NULL COMMENT '字典ID',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典项名称',
  `value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典项值',
  `status` tinyint DEFAULT '0' COMMENT '状态（1-正常，0-禁用）',
  `sort` int DEFAULT '0' COMMENT '排序',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `name`, `value`, `status`, `sort`, `remark`, `create_time`, `update_time`) VALUES (99, 1, '男', '1', 1, 1, '', NULL, NULL);
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `name`, `value`, `status`, `sort`, `remark`, `create_time`, `update_time`) VALUES (100, 1, '女', '2', 1, 2, '', NULL, NULL);
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `name`, `value`, `status`, `sort`, `remark`, `create_time`, `update_time`) VALUES (101, 1, '保密', '0', 1, 3, '', NULL, NULL);
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `name`, `value`, `status`, `sort`, `remark`, `create_time`, `update_time`) VALUES (110, 102, '图片', '1', 1, 1, '', NULL, NULL);
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `name`, `value`, `status`, `sort`, `remark`, `create_time`, `update_time`) VALUES (111, 102, '音频', '2', 1, 1, '', NULL, NULL);
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `name`, `value`, `status`, `sort`, `remark`, `create_time`, `update_time`) VALUES (112, 102, '视频', '3', 1, 1, '', NULL, NULL);
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `name`, `value`, `status`, `sort`, `remark`, `create_time`, `update_time`) VALUES (113, 102, '其他', '4', 1, 1, '', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_file_meta
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_meta`;
CREATE TABLE `sys_file_meta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `file_path_cos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '腾讯cos文件路径',
  `mine_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'mime类型，如：image/jpeg；audio/wav',
  `file_type` int NOT NULL COMMENT '文件类型：1:图片；2:音频；3:视频',
  `file_use` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件用途子目录（cos上分的子目录名称）',
  `file_extension` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件扩展名',
  `model_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '模块类型：1：文章模块 2：头像 3：音频封面  4：商品图  99：暂无用途',
  `file_size` int DEFAULT NULL COMMENT '文件大小',
  `upload_time` datetime DEFAULT NULL COMMENT '文件上传时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of sys_file_meta
-- ----------------------------
BEGIN;
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (1, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_11_23_42_29_3716_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1816624, '2024-11-11 23:42:30');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (2, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_11_23_44_09_7191_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1816624, '2024-11-11 23:44:10');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (3, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_11_23_44_12_3789_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1816624, '2024-11-11 23:44:13');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (4, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_11_23_44_52_3945_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1816624, '2024-11-11 23:44:53');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (5, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_11_23_45_41_7718_123.png', 'image/png', 1, 'gin_test', '.png', '', 1238512, '2024-11-11 23:45:41');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (6, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_14_12_23_6277_123.png', 'image/png', 1, 'gin_test', '.png', '', 1238512, '2024-11-12 14:12:24');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (7, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_14_21_57_3326_123.png', 'image/png', 1, 'gin_test', '.png', '', 2041973, '2024-11-12 14:21:59');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (8, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_14_24_05_6326_123.png', 'image/png', 1, 'gin_test', '.png', '', 292872, '2024-11-12 14:24:06');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (9, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_14_24_54_0108_123.png', 'image/png', 1, 'gin_test', '.png', '', 2041973, '2024-11-12 14:24:55');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (10, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_14_38_08_4930_123.png', 'image/png', 1, 'gin_test', '.png', '', 1238512, '2024-11-12 14:38:09');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (11, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_14_41_59_0235_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1816624, '2024-11-12 14:42:00');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (12, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_16_17_8743_123.png', 'image/png', 1, 'gin_test', '.png', '', 292872, '2024-11-12 15:16:18');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (13, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_45_49_1420_123.png', 'image/png', 1, 'gin_test', '.png', '', 292872, '2024-11-12 15:45:50');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (14, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_47_24_5895_123.png', 'image/png', 1, 'gin_test', '.png', '', 2041973, '2024-11-12 15:47:26');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (15, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_49_07_4009_123.png', 'image/png', 1, 'gin_test', '.png', '', 2041973, '2024-11-12 15:49:08');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (16, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_49_48_6242_123.png', 'image/png', 1, 'gin_test', '.png', '', 2041973, '2024-11-12 15:49:49');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (17, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_04_0473_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 15:51:06');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (18, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_04_0466_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 15:51:06');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (19, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_20_1127_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1233012, '2024-11-12 15:51:21');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (20, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_20_3238_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2632921, '2024-11-12 15:51:21');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (21, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_20_9989_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1405195, '2024-11-12 15:51:21');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (22, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_21_4039_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3853687, '2024-11-12 15:51:22');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (23, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_22_4250_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1492501, '2024-11-12 15:51:24');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (24, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_20_5589_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1885389, '2024-11-12 15:51:24');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (25, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_21_4674_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 4722745, '2024-11-12 15:51:25');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (26, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_21_6088_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2805333, '2024-11-12 15:51:25');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (27, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_24_6090_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 15:51:25');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (28, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_20_7152_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3059829, '2024-11-12 15:51:25');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (29, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_24_5077_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 15:51:26');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (30, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_25_9120_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 15:51:27');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (31, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_51_20_7025_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 6838110, '2024-11-12 15:51:28');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (32, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_02_6056_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 15:52:03');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (33, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_05_7445_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 15:52:06');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (34, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_09_1609_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3853687, '2024-11-12 15:52:10');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (35, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_12_3529_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2805333, '2024-11-12 15:52:13');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (36, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_21_6446_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 15:52:22');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (37, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_21_0121_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 15:52:23');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (38, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_29_7120_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1492501, '2024-11-12 15:52:30');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (39, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_29_6953_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 15:52:30');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (40, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_29_3260_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 15:52:30');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (41, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_52_29_2516_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 15:52:30');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (42, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_54_17_9331_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 15:54:18');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (43, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_54_17_7066_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 15:54:18');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (44, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_15_54_17_0098_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 15:54:18');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (45, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_03_03_0581_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 6838110, '2024-11-12 16:03:05');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (46, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_03_59_7321_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1885389, '2024-11-12 16:04:00');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (47, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_04_20_9346_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3059829, '2024-11-12 16:04:21');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (48, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_15_7173_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 16:05:16');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (49, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_19_2322_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2805333, '2024-11-12 16:05:20');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (50, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_20_5153_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1492501, '2024-11-12 16:05:21');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (51, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_19_5356_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 16:05:22');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (52, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_19_1854_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 16:05:22');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (53, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_20_3220_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 16:05:23');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (54, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_19_7236_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3853687, '2024-11-12 16:05:24');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (55, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_19_7432_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 4722745, '2024-11-12 16:05:24');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (56, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_05_19_9325_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 6838110, '2024-11-12 16:05:25');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (57, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_06_48_8753_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 16:06:49');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (58, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_06_48_7924_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1492501, '2024-11-12 16:06:49');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (59, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_06_48_8510_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 16:06:49');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (60, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_06_48_4619_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 16:06:50');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (61, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_42_4145_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 6838110, '2024-11-12 16:18:44');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (62, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_53_0982_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3031856, '2024-11-12 16:18:54');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (63, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_53_2671_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1885389, '2024-11-12 16:18:54');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (64, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_54_7935_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1233012, '2024-11-12 16:18:55');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (65, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_54_9526_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2805333, '2024-11-12 16:18:55');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (66, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_54_8574_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1492501, '2024-11-12 16:18:55');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (67, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_54_7000_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2632921, '2024-11-12 16:18:56');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (68, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_54_7444_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3059829, '2024-11-12 16:18:57');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (69, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_55_1715_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1520438, '2024-11-12 16:18:57');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (70, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_55_0603_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 16:18:58');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (71, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_56_7035_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1405195, '2024-11-12 16:18:59');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (72, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_55_7287_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 4722745, '2024-11-12 16:19:00');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (73, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_55_0910_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2800889, '2024-11-12 16:19:00');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (74, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_56_6318_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3853687, '2024-11-12 16:19:01');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (75, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_18_54_1216_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 6838110, '2024-11-12 16:19:01');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (76, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_20_03_2330_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 2026639, '2024-11-12 16:20:05');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (77, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_21_39_7996_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1885389, '2024-11-12 16:21:41');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (78, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_21_39_0441_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 1405195, '2024-11-12 16:21:41');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (79, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_12_16_21_39_5283_123.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 3059829, '2024-11-12 16:21:41');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (80, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_16_16_19_37_5372_2.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 787537, '2024-11-16 16:19:39');
INSERT INTO `sys_file_meta` (`id`, `file_path_cos`, `mine_type`, `file_type`, `file_use`, `file_extension`, `model_type`, `file_size`, `upload_time`) VALUES (81, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/2024/11/2024_11_19_09_54_25_7180_2.jpg', 'image/jpeg', 1, 'gin_test', '.jpg', '', 303351, '2024-11-19 09:54:26');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `module` enum('LOGIN','USER','ROLE','DEPT','MENU','DICT','OTHER') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志模块',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志内容',
  `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求路径',
  `ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'IP地址',
  `province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '省份',
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '城市',
  `execution_time` bigint DEFAULT NULL COMMENT '执行时间(ms)',
  `browser` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器',
  `browser_version` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器版本',
  `os` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '终端系统',
  `create_by` bigint DEFAULT NULL COMMENT '创建人ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除标识(1-已删除 0-未删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统日志表';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (1, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 14, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:36:55', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (2, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 23, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:36:59', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (3, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 15, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:37:01', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (4, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 10, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:37:01', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (5, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 8, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:37:01', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (6, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 6, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:37:11', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (7, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 14, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:05', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (8, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 9, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:27', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (9, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 10, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:49', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (10, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 14, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:49', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (11, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 8, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:49', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (12, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 9, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:50', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (13, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 9, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:51', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (14, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 8, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:51', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (15, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 8, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:52', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (16, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 10, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:52', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (17, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 5, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:38:52', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (18, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 7, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:39:01', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (19, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 10, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:39:04', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (20, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 10, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:39:06', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (21, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 7, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:40:10', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (22, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 19, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:40:35', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (23, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 15, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:41:02', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (24, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 8, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:41:06', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (25, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 12, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:41:06', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (26, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 13, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:41:12', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (27, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 9, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:41:16', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (28, 'MENU', '菜单列表', '/api/v1/menus', '127.0.0.1', '0', '内网IP', 21, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:42:38', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (29, 'DICT', '字典分页列表', '/api/v1/dict/page', '127.0.0.1', '0', '内网IP', 24, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:42:55', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (30, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 22, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:43:35', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (31, 'ROLE', '角色分页列表', '/api/v1/roles/page', '127.0.0.1', '0', '内网IP', 11, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:43:52', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (32, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 32, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:45:32', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (33, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 28, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:45:44', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (34, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 24, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:45:46', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (35, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 39, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:45:49', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (36, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 22, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:46:17', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (37, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 31, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:49:31', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (38, 'ROLE', '角色分页列表', '/api/v1/roles/page', '127.0.0.1', '0', '内网IP', 14, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:49:32', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (39, 'MENU', '菜单列表', '/api/v1/menus', '127.0.0.1', '0', '内网IP', 15, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:49:33', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (40, 'DEPT', '部门列表', '/api/v1/dept', '127.0.0.1', '0', '内网IP', 6, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:49:33', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (41, 'DICT', '字典分页列表', '/api/v1/dict/page', '127.0.0.1', '0', '内网IP', 12, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:49:34', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (42, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 18, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:54:26', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (43, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 15, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:54:35', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (44, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 12, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:54:40', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (45, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 19, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:54:47', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (46, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 18, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 21:55:08', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (47, 'DICT', '字典分页列表', '/api/v1/dict/page', '127.0.0.1', '0', '内网IP', 22, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 22:56:57', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (48, 'DICT', '字典分页列表', '/api/v1/dict/page', '127.0.0.1', '0', '内网IP', 24, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-14 22:56:59', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (49, 'LOGIN', '登录', '/api/v1/auth/login', '127.0.0.1', '0', '内网IP', 246, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-15 08:34:36', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (50, 'USER', '用户分页列表', '/api/v1/users/page', '127.0.0.1', '0', '内网IP', 18, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-15 08:34:36', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (51, 'ROLE', '角色分页列表', '/api/v1/roles/page', '127.0.0.1', '0', '内网IP', 10, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-15 08:36:36', 0);
INSERT INTO `sys_log` (`id`, `module`, `content`, `request_uri`, `ip`, `province`, `city`, `execution_time`, `browser`, `browser_version`, `os`, `create_by`, `create_time`, `is_deleted`) VALUES (52, 'MENU', '菜单列表', '/api/v1/menus', '127.0.0.1', '0', '内网IP', 25, 'Chrome', '126.0.0.0', 'OSX', 2, '2024-07-15 08:36:38', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `parent_id` bigint NOT NULL COMMENT '父菜单ID',
  `tree_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父节点ID路径',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
  `type` tinyint NOT NULL COMMENT '菜单类型（1-菜单 2-目录 3-外链 4-按钮）',
  `route_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '路由名称（Vue Router 中用于命名路由）',
  `route_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '路由路径（Vue Router 中定义的 URL 路径）',
  `component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件路径（组件页面完整路径，相对于 src/views/，缺省后缀 .vue）',
  `perm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '【按钮】权限标识',
  `always_show` tinyint DEFAULT NULL COMMENT '【目录】只有一个子路由是否始终显示（1-是 0-否）',
  `keep_alive` tinyint DEFAULT NULL COMMENT '【菜单】是否开启页面缓存（1-是 0-否）',
  `visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT '显示状态（1-显示 0-隐藏）',
  `sort` int DEFAULT '0' COMMENT '排序',
  `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '菜单图标',
  `redirect` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '跳转路径',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `params` json DEFAULT NULL COMMENT '路由参数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (1, 0, '0', '系统管理', 2, '', '/system', 'Layout', NULL, NULL, NULL, 1, 1, 'system', '/system/user', '2021-08-28 09:12:21', '2024-06-24 23:49:04', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (2, 1, '0,1', '用户管理', 1, 'User', 'user', 'system/user/index', NULL, NULL, 1, 1, 1, 'user', NULL, '2021-08-28 09:12:21', '2021-08-28 09:12:21', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (3, 1, '0,1', '角色管理', 1, 'Role', 'role', 'system/role/index', NULL, NULL, 1, 1, 2, 'role', NULL, '2021-08-28 09:12:21', '2021-08-28 09:12:21', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (4, 1, '0,1', '菜单管理', 1, 'Menu', 'menu', 'system/menu/index', NULL, NULL, 1, 1, 3, 'menu', NULL, '2021-08-28 09:12:21', '2021-08-28 09:12:21', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (5, 1, '0,1', '部门管理', 1, 'Dept', 'dept', 'system/dept/index', NULL, NULL, 1, 1, 4, 'tree', NULL, '2021-08-28 09:12:21', '2021-08-28 09:12:21', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (6, 1, '0,1', '字典管理', 1, 'Dict', 'dict', 'system/dict/index', NULL, NULL, 1, 1, 5, 'dict', NULL, '2021-08-28 09:12:21', '2021-08-28 09:12:21', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (20, 0, '0', '多级菜单', 2, NULL, '/multi-level', 'Layout', NULL, 1, NULL, 1, 9, 'cascader', '', '2022-02-16 23:11:00', '2022-02-16 23:11:00', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (21, 20, '0,20', '菜单一级', 1, NULL, 'multi-level1', 'demo/multi-level/level1', NULL, 1, NULL, 1, 1, '', '', '2022-02-16 23:13:38', '2022-02-16 23:13:38', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (22, 21, '0,20,21', '菜单二级', 1, NULL, 'multi-level2', 'demo/multi-level/children/level2', NULL, 0, NULL, 1, 1, '', NULL, '2022-02-16 23:14:23', '2022-02-16 23:14:23', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (23, 22, '0,20,21,22', '菜单三级-1', 1, NULL, 'multi-level3-1', 'demo/multi-level/children/children/level3-1', NULL, 0, 1, 1, 1, '', '', '2022-02-16 23:14:51', '2022-02-16 23:14:51', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (24, 22, '0,20,21,22', '菜单三级-2', 1, NULL, 'multi-level3-2', 'demo/multi-level/children/children/level3-2', NULL, 0, 1, 1, 2, '', '', '2022-02-16 23:15:08', '2022-02-16 23:15:08', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (26, 0, '0', '平台文档', 2, NULL, '/doc', 'Layout', NULL, NULL, NULL, 1, 8, 'document', 'https://juejin.cn/post/7228990409909108793', '2022-02-17 22:51:20', '2022-02-17 22:51:20', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (30, 26, '0,26', '平台文档(外链)', 3, NULL, 'https://juejin.cn/post/7228990409909108793', '', NULL, NULL, NULL, 1, 2, 'link', '', '2022-02-18 00:01:40', '2022-02-18 00:01:40', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (31, 2, '0,1,2', '用户新增', 4, NULL, '', NULL, 'sys:user:add', NULL, NULL, 1, 1, '', '', '2022-10-23 11:04:08', '2022-10-23 11:04:11', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (32, 2, '0,1,2', '用户编辑', 4, NULL, '', NULL, 'sys:user:edit', NULL, NULL, 1, 2, '', '', '2022-10-23 11:04:08', '2022-10-23 11:04:11', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (33, 2, '0,1,2', '用户删除', 4, NULL, '', NULL, 'sys:user:delete', NULL, NULL, 1, 3, '', '', '2022-10-23 11:04:08', '2022-10-23 11:04:11', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (36, 0, '0', '组件封装', 2, NULL, '/component', 'Layout', NULL, NULL, NULL, 1, 10, 'menu', '', '2022-10-31 09:18:44', '2022-10-31 09:18:47', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (37, 36, '0,36', '富文本编辑器', 1, NULL, 'wang-editor', 'demo/wang-editor', NULL, NULL, 1, 1, 2, '', '', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (38, 36, '0,36', '图片上传', 1, NULL, 'upload', 'demo/upload', NULL, NULL, 1, 1, 3, '', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (39, 36, '0,36', '图标选择器', 1, NULL, 'icon-selector', 'demo/icon-selector', NULL, NULL, 1, 1, 4, '', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (40, 0, '0', '接口文档', 2, NULL, '/api', 'Layout', NULL, 1, NULL, 1, 7, 'api', '', '2022-02-17 22:51:20', '2022-02-17 22:51:20', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (41, 40, '0,40', 'Apifox', 1, NULL, 'apifox', 'demo/api/apifox', NULL, NULL, 1, 1, 1, 'api', '', '2022-02-17 22:51:20', '2022-02-17 22:51:20', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (70, 3, '0,1,3', '角色新增', 4, NULL, '', NULL, 'sys:role:add', NULL, NULL, 1, 1, '', NULL, '2023-05-20 23:39:09', '2023-05-20 23:39:09', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (71, 3, '0,1,3', '角色编辑', 4, NULL, '', NULL, 'sys:role:edit', NULL, NULL, 1, 2, '', NULL, '2023-05-20 23:40:31', '2023-05-20 23:40:31', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (72, 3, '0,1,3', '角色删除', 4, NULL, '', NULL, 'sys:role:delete', NULL, NULL, 1, 3, '', NULL, '2023-05-20 23:41:08', '2023-05-20 23:41:08', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (73, 4, '0,1,4', '菜单新增', 4, NULL, '', NULL, 'sys:menu:add', NULL, NULL, 1, 1, '', NULL, '2023-05-20 23:41:35', '2023-05-20 23:41:35', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (74, 4, '0,1,4', '菜单编辑', 4, NULL, '', NULL, 'sys:menu:edit', NULL, NULL, 1, 3, '', NULL, '2023-05-20 23:41:58', '2023-05-20 23:41:58', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (75, 4, '0,1,4', '菜单删除', 4, NULL, '', NULL, 'sys:menu:delete', NULL, NULL, 1, 3, '', NULL, '2023-05-20 23:44:18', '2023-05-20 23:44:18', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (76, 5, '0,1,5', '部门新增', 4, NULL, '', NULL, 'sys:dept:add', NULL, NULL, 1, 1, '', NULL, '2023-05-20 23:45:00', '2023-05-20 23:45:00', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (77, 5, '0,1,5', '部门编辑', 4, NULL, '', NULL, 'sys:dept:edit', NULL, NULL, 1, 2, '', NULL, '2023-05-20 23:46:16', '2023-05-20 23:46:16', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (78, 5, '0,1,5', '部门删除', 4, NULL, '', NULL, 'sys:dept:delete', NULL, NULL, 1, 3, '', NULL, '2023-05-20 23:46:36', '2023-05-20 23:46:36', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (79, 6, '0,1,6', '字典类型新增', 4, NULL, '', NULL, 'sys:dict_type:add', NULL, NULL, 1, 1, '', NULL, '2023-05-21 00:16:06', '2023-05-21 00:16:06', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (81, 6, '0,1,6', '字典类型编辑', 4, NULL, '', NULL, 'sys:dict_type:edit', NULL, NULL, 1, 2, '', NULL, '2023-05-21 00:27:37', '2023-05-21 00:27:37', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (84, 6, '0,1,6', '字典类型删除', 4, NULL, '', NULL, 'sys:dict_type:delete', NULL, NULL, 1, 3, '', NULL, '2023-05-21 00:29:39', '2023-05-21 00:29:39', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (85, 6, '0,1,6', '字典数据新增', 4, NULL, '', NULL, 'sys:dict:add', NULL, NULL, 1, 4, '', NULL, '2023-05-21 00:46:56', '2023-05-21 00:47:06', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (86, 6, '0,1,6', '字典数据编辑', 4, NULL, '', NULL, 'sys:dict:edit', NULL, NULL, 1, 5, '', NULL, '2023-05-21 00:47:36', '2023-05-21 00:47:36', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (87, 6, '0,1,6', '字典数据删除', 4, NULL, '', NULL, 'sys:dict:delete', NULL, NULL, 1, 6, '', NULL, '2023-05-21 00:48:10', '2023-05-21 00:48:20', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (88, 2, '0,1,2', '重置密码', 4, NULL, '', NULL, 'sys:user:password:reset', NULL, NULL, 1, 4, '', NULL, '2023-05-21 00:49:18', '2024-04-28 00:38:22', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (89, 0, '0', '功能演示', 2, NULL, '/function', 'Layout', NULL, NULL, NULL, 1, 12, 'menu', '', '2022-10-31 09:18:44', '2024-05-26 21:05:25', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (90, 89, '0,89', 'Websocket', 1, NULL, '/function/websocket', 'demo/websocket', NULL, NULL, 1, 1, 3, '', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (91, 89, '0,89', '敬请期待...', 2, NULL, 'other/:id', 'demo/other', NULL, NULL, NULL, 1, 4, '', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (95, 36, '0,36', '字典组件', 1, NULL, 'dict-demo', 'demo/dict', NULL, NULL, 1, 1, 4, '', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (97, 89, '0,89', 'Icons', 1, NULL, 'icon-demo', 'demo/icons', NULL, NULL, 1, 1, 2, 'el-icon-Notification', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (102, 26, '0,26', '平台文档(内嵌)', 3, NULL, 'internal-doc', 'demo/internal-doc', NULL, NULL, NULL, 1, 1, 'document', '', '2022-02-18 00:01:40', '2022-02-18 00:01:40', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (105, 2, '0,1,2', '用户查询', 4, NULL, '', NULL, 'sys:user:query', 0, 0, 1, 0, '', NULL, '2024-04-28 00:37:34', '2024-04-28 00:37:34', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (106, 2, '0,1,2', '用户导入', 4, NULL, '', NULL, 'sys:user:import', NULL, NULL, 1, 5, '', NULL, '2024-04-28 00:39:15', '2024-04-28 00:39:15', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (107, 2, '0,1,2', '用户导出', 4, NULL, '', NULL, 'sys:user:export', NULL, NULL, 1, 6, '', NULL, '2024-04-28 00:39:43', '2024-04-28 00:39:43', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (108, 36, '0,36', '增删改查', 1, NULL, 'curd', 'demo/curd/index', NULL, NULL, 1, 1, 0, '', '', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (109, 36, '0,36', '列表选择器', 1, NULL, 'table-select', 'demo/table-select/index', NULL, NULL, 1, 1, 1, '', '', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (110, 0, '0', '路由参数', 2, NULL, '/route-param', 'Layout', NULL, 1, 1, 1, 11, 'el-icon-ElementPlus', NULL, '2024-05-26 21:05:09', '2024-05-26 21:05:34', NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (111, 110, '0,110', '参数(type=1)', 1, NULL, 'route-param-type1', 'demo/route-param', NULL, 0, 1, 1, 1, 'el-icon-Star', NULL, '2024-05-26 21:59:24', '2024-05-26 21:59:37', '{\"type\": \"1\"}');
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (112, 110, '0,110', '参数(type=2)', 1, NULL, 'route-param-type2', 'demo/route-param', NULL, 0, 1, 1, 2, 'el-icon-StarFilled', NULL, '2024-05-26 21:46:55', '2024-05-26 21:59:45', '{\"type\": \"2\"}');
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (117, 1, '0,1', '系统日志', 1, '', '', 'system/log/index', '', 0, 1, 0, 6, 'document', '', '2024-06-28 07:43:16', '2024-06-28 07:43:16', '{}');
INSERT INTO `sys_menu` (`id`, `parent_id`, `tree_path`, `name`, `type`, `route_name`, `route_path`, `component`, `perm`, `always_show`, `keep_alive`, `visible`, `sort`, `icon`, `redirect`, `create_time`, `update_time`, `params`) VALUES (122, 36, '0,36', '切片上传', 1, '', 'slice-upload', 'demo/slice-upload/index', '', 0, 1, 1, 1, 'menu', '', NULL, NULL, '{}');
COMMIT;

-- ----------------------------
-- Table structure for sys_message
-- ----------------------------
DROP TABLE IF EXISTS `sys_message`;
CREATE TABLE `sys_message` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_by` bigint DEFAULT NULL COMMENT '创建人ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除标识(1-已删除 0-未删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统消息';

-- ----------------------------
-- Records of sys_message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色编码',
  `sort` int DEFAULT NULL COMMENT '显示顺序',
  `status` tinyint(1) DEFAULT '1' COMMENT '角色状态(1-正常 0-停用)',
  `data_scope` tinyint DEFAULT NULL COMMENT '数据权限(0-所有数据 1-部门及子部门数据 2-本部门数据3-本人数据)',
  `create_by` bigint DEFAULT NULL COMMENT '创建人 ID',
  `create_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人ID',
  `update_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标识(0-未删除 1-已删除)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_name` (`name`) USING BTREE COMMENT '角色名称唯一索引',
  UNIQUE KEY `uk_code` (`code`) USING BTREE COMMENT '角色编码唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=1006 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `code`, `sort`, `status`, `data_scope`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (1, '超级管理员', 'ROOT', 1, 1, 0, NULL, '2021-05-21 14:56:51', NULL, '2018-12-23 16:00:00', 0);
INSERT INTO `sys_role` (`id`, `name`, `code`, `sort`, `status`, `data_scope`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (2, '系统管理员', 'ADMIN', 2, 1, 1, NULL, '2021-03-25 12:39:54', NULL, NULL, 0);
INSERT INTO `sys_role` (`id`, `name`, `code`, `sort`, `status`, `data_scope`, `create_by`, `create_time`, `update_by`, `update_time`, `is_deleted`) VALUES (1005, '测试管理员11', 'TEST11', 1, 1, 0, NULL, '2024-11-19 14:27:04', NULL, '2024-11-19 15:26:10', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  UNIQUE KEY `uk_roleid_menuid` (`role_id`,`menu_id`) USING BTREE COMMENT '角色菜单唯一索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 2);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 3);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 4);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 5);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 6);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 20);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 21);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 22);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 23);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 24);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 26);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 30);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 31);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 32);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 33);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 36);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 37);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 38);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 39);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 40);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 41);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 70);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 71);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 72);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 73);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 74);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 75);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 76);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 77);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 78);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 79);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 81);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 84);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 85);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 86);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 87);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 88);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 89);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 90);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 91);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 95);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 97);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 102);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 105);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 106);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 107);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 108);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 109);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 110);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 111);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 112);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 117);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 122);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 1);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 2);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 3);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 4);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 5);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 6);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 31);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 32);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 33);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 36);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 37);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 38);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 39);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 70);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 71);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 72);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 73);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 74);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 75);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 76);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 77);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 78);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 79);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 81);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 84);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 85);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 86);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 87);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 88);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 95);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 105);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 106);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 107);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 108);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 109);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 117);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1005, 122);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '昵称',
  `gender` tinyint(1) DEFAULT '1' COMMENT '性别((1-男 2-女 0-保密)',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `dept_id` int DEFAULT NULL COMMENT '部门ID',
  `avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户头像',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系方式',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态((1-正常 0-禁用)',
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户邮箱',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '修改人ID',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除标识(0-未删除 1-已删除)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `login_name` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `gender`, `password`, `dept_id`, `avatar`, `mobile`, `status`, `email`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`) VALUES (1, 'root', '有来技术gt', 0, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', NULL, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/xjj.jpg', '17621590365', 1, 'youlaitech@163.com', NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `gender`, `password`, `dept_id`, `avatar`, `mobile`, `status`, `email`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`) VALUES (2, 'admin', '系统管理员admin', 1, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', 1, 'https://sanjitian-1256310189.cos.ap-chengdu.myqcloud.com/gin_test/xjj.jpg', '17621210366', 1, '', '2019-10-10 13:41:22', NULL, '2022-07-31 12:39:30', NULL, 0);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `gender`, `password`, `dept_id`, `avatar`, `mobile`, `status`, `email`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`) VALUES (354, 'daiyushuo', '戴玉朔', 1, '$2a$10$8j8suzCX77aSqj57mHvxEeHDyDNPXIxTh8dZCeZAIkXYO9mTzZZYO', 1, '', '19350369664', 1, '312995423@qq.com', '2024-11-19 14:23:21', NULL, '2024-11-19 15:48:19', NULL, 0);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `gender`, `password`, `dept_id`, `avatar`, `mobile`, `status`, `email`, `create_time`, `create_by`, `update_time`, `update_by`, `is_deleted`) VALUES (355, 'test1', '测试用户1', 1, '$2a$10$.gPLMDIYULRiNBknBFupCOn0Z6RGqJJh3zBmBU/Q89mwKO/qD3.5.', 2, '', '13661222494', 1, '3129987@qq.com', '2024-11-19 14:24:16', NULL, '2024-11-19 15:25:48', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  UNIQUE KEY `uk_userid_roleid` (`user_id`,`role_id`) USING BTREE COMMENT '用户角色唯一索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1, 1);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (2, 2);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (354, 1005);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (355, 2);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (355, 1005);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
